Owner

dbo

Creation Date

10-07-2003 10:31:36

Remarks

Columns

Name	Type	Length	IsNullable	Collation
CustomerID	nchar	10		SQL_Latin1_General_CP1_CI_AS
CompanyName	nvarchar	80		SQL_Latin1_General_CP1_CI_AS
CompanyName	sysname	80		SQL_Latin1_General_CP1_CI_AS
City	nvarchar	30		SQL_Latin1_General_CP1_CI_AS
City	sysname	30		SQL_Latin1_General_CP1_CI_AS
Country	nvarchar	30		SQL_Latin1_General_CP1_CI_AS
Country	sysname	30		SQL_Latin1_General_CP1_CI_AS

View Definition

create view "Quarterly Orders" AS
SELECT DISTINCT Customers.CustomerID, Customers.CompanyName, Customers.City, Customers.Country
FROM Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID
WHERE Orders.OrderDate BETWEEN '19970101' And '19971231'